[dbo].[BAEOrderSuperProductChildProductLoad]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEOrderSuperProductChildProductLoad

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)
@OrderSuperProductChildProductID	int	4

create procedure [dbo].[BAEOrderSuperProductChildProductLoad] @OrderSuperProductChildProductID as
int
AS
    SELECT op.OrderProductID AS 'ChildProductID', i.TITLE, osp.OrderSuperProductChildProductID,osp.OrderProductID,osp.ProductCode,osp.DefaultForPrice
    FROM OrderProduct AS op JOIN OrderSuperProductChildProduct AS osp
    ON op.ProductCode COLLATE database_default = osp.ProductCode COLLATE database_default JOIN Product AS i ON i.PRODUCT_CODE COLLATE database_default = op.ProductCode COLLATE database_default WHERE osp.OrderSuperProductChildProductID = @OrderSuperProductChildProductID;

GO